<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en">
  <title id="ij138244">citext</title>
  <body>
    <p>The citext module provides a case-insensitive character string data type,
      <codeph>citext</codeph>. Essentially, it internally calls the
      <codeph>lower()</codeph> function when comparing values. Otherwise, it behaves
      almost exactly like the <codeph>text</codeph> data type.</p>
    <p>The Greenplum Database <codeph>citext</codeph> module is equivalent to the
      PostgreSQL <codeph>citext</codeph> module. There are no Greenplum Database or
      MPP-specific considerations for the module.</p>
  </body>
  <topic id="topic_reg">
    <title>Installing and Registering the Module</title>
    <body>
      <p>The <codeph>citext</codeph> module is installed when you install
        Greenplum Database. Before you can use any of the data types, operators, or
        functions defined in the module, you must register the <codeph>citext</codeph>
        extension in each database in which you want to use the objects.
        <ph otherprops="pivotal">Refer to <xref href="../../install_guide/install_modules.html"
          format="html" scope="external">Installing Additional Supplied Modules</xref>
        for more information.</ph></p>
    </body>
  </topic>
  <topic id="topic_info">
    <title>Module Documentation</title>
    <body>
      <p>See <xref href="https://www.postgresql.org/docs/9.4/citext.html"
        format="html" scope="external">citext</xref> in the PostgreSQL
        documentation for detailed information about the data types, operators, and
        functions defined in this module.</p>
    </body>
  </topic>
</topic>
